package com.example.qxfw.qxxx.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.qxfw.common.entity.qx.Satellitenephoram;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.sql.Timestamp;
import java.util.List;

@Mapper
@DS("qx")
public interface SatellitenephoramMapper extends BaseMapper<Satellitenephoram> {

    @Select("select datayear, datechar, timechar, yttype, path, lbimgpath, jwimgpath, satetitle, serverpath, state, west, south, east, north, fwest, fsouth, feast, fnorth " +
            "from satellitenephoram " +
            "where yttype= #{ytType} and datechar between #{timeStart} and #{timeEnd}")
    List<Satellitenephoram> selectList(@Param("ytType") String ytType, @Param("timeStart") Timestamp timeStart, @Param("timeEnd") Timestamp timeEnd);
}
